UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmG1mNlV/RiWKgWWqS9WlXhsWiuncc2uObIbDU6thZ4='
WHERE
key_id = '0e74289df94470bdb298c9aa8953af25bf28643a4a4c9592a5fdf77163788797'
AND (
token = 'SmG1mNlV/RiWKgWWqS9WlXhsWiuncc2uObIbDU6thZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)