UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GC8cofhHaYLr0fEaGEsq0qsWo87mNNSCaDSGXHY6Ojo='
WHERE
key_id = '12c15e198dad145d7a5b85903ba90052e3173e0b2c5614dbff2b16c2f3e287cb'
AND (
token = 'GC8cofhHaYLr0fEaGEsq0qsWo87mNNSCaDSGXHY6Ojo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)