UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGmN0NNdi6jUiRePZ/Dpty3Z+tmP+34M5bXDBZxW8PQ='
WHERE
key_id = '7ef02caa1bab6ed1f4127ac06c2389e7d1de08f10c28eff25f8e3960c2b2be5b'
AND (
token = 'CGmN0NNdi6jUiRePZ/Dpty3Z+tmP+34M5bXDBZxW8PQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)