UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CRbO42nL0G4u9Hnljy4MzQ1eUOOaXmFl7FN7WzkwHIA='
WHERE
key_id = '1e2ad17f5fbdf77668af2bc219b7d71f713a4d48730a43997149508b6a39759d'
AND (
token = 'CRbO42nL0G4u9Hnljy4MzQ1eUOOaXmFl7FN7WzkwHIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)