UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xf0mY5jmNdIeZp98F9+t5QQMUy5F3li2EBDE5J08jfA='
WHERE
key_id = '97a52b1c887ef9f46047b3fa7947fcdfa3ba67474fb121c167ffb08e61bd4db7'
AND (
token = 'Xf0mY5jmNdIeZp98F9+t5QQMUy5F3li2EBDE5J08jfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)