UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vh9hz9c8lk8FdnH7XXO5ywOKOXVUZh2NUrT9wvfthU8='
WHERE
key_id = '9d8b10cad3f47afac1b25bc4f2ab49d066173fa91a48ab040c8f881e78c8b451'
AND (
token = 'Vh9hz9c8lk8FdnH7XXO5ywOKOXVUZh2NUrT9wvfthU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)