UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qh0GLzy8V3BkHeJ3C3rdO9m/TaaUjwxnA1JFXI0HHg8='
WHERE
key_id = 'e9d569e4c095087cd115120a8e661c18688b29991147d2fdea9102da4faca5ae'
AND (
token = 'qh0GLzy8V3BkHeJ3C3rdO9m/TaaUjwxnA1JFXI0HHg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)