UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27C8qOCD5Gl9gqAtQChhfK2OI9nm3PsoTPLk53EfQNc='
WHERE
key_id = 'd099efe6addd13bf985c1a5581d6f91601786ca4b62bad10bfa9ca70724cb968'
AND (
token = '27C8qOCD5Gl9gqAtQChhfK2OI9nm3PsoTPLk53EfQNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)