UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqoXSoJnUntgmwW2gMzMF6L4u6Dft1dC0AwfL+rhs8k='
WHERE
key_id = 'd004bb3865d957e9ea5dbbf4492f8b92b03b050e4ac1860aa6fd444b2bb03960'
AND (
token = 'ZqoXSoJnUntgmwW2gMzMF6L4u6Dft1dC0AwfL+rhs8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)