UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fEY3DLxjhCbhQelGf8/32zfrIYzCXOuM5QUFo6TLblc='
WHERE
key_id = 'e4c1ee0b25bae6b0572e4a9dfce19b442d0b495a78b10f64f7399b7f1654a962'
AND (
token = 'fEY3DLxjhCbhQelGf8/32zfrIYzCXOuM5QUFo6TLblc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)