UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2B2DClQ3V+ZNgWpG3T5Tu2sz1OGicRqSm7Ef8hpTna8='
WHERE
key_id = '55d66e1826e61c9f0acee14e3894e6a1951cf3740f2585ba309012a17c550514'
AND (
token = '2B2DClQ3V+ZNgWpG3T5Tu2sz1OGicRqSm7Ef8hpTna8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)