UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hNKh4qnLBL8C6QvdHJSyYV6VqaWHXpYlveXc1ZkCUrU='
WHERE
key_id = '0bd67e6db23fdc4f29c1f8cea04314adb9b48c1ae35cf366b80045ee8c8002d3'
AND (
token = 'hNKh4qnLBL8C6QvdHJSyYV6VqaWHXpYlveXc1ZkCUrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)