UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzLEUhVq38BKM3+YS5qeg9nE/x+wwS3zOBxCWmha/mo='
WHERE
key_id = '87e1c28170840a632ef6151de96b481320f2e98ec0aecb0738973f15940bbe20'
AND (
token = 'JzLEUhVq38BKM3+YS5qeg9nE/x+wwS3zOBxCWmha/mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)