UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BAoVpM7/E5xkVgwNsOV+C6uNJBtNHgvqCu5W42Wmnk='
WHERE
key_id = 'c6bc60846bad3c79bc802810623e8e0b735f085d42e841b5214f94c165a6e223'
AND (
token = '8BAoVpM7/E5xkVgwNsOV+C6uNJBtNHgvqCu5W42Wmnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)