UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0fytLKH2rXFU34hNw9i0Q0XJ8VVecI57v29Ai4tj1E='
WHERE
key_id = 'c947f05f3c46d9c4a25ff356fbc5d79b945f094b89ffe8eceae3f176e5a6efaf'
AND (
token = 'R0fytLKH2rXFU34hNw9i0Q0XJ8VVecI57v29Ai4tj1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)