UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7fUVqt0DUlW1ocWHd3TxnkZv0Bq+H0LY9/ajOlYNXg='
WHERE
key_id = '42c797905fb87ab1cf4d42cbca48a322a4c4707fff4362ad93a01d2a101ed5ad'
AND (
token = 'r7fUVqt0DUlW1ocWHd3TxnkZv0Bq+H0LY9/ajOlYNXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)