UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPsSsfe37PMQrgO0nRuYgLElncrXqHE1YgWqkim4zX4='
WHERE
key_id = 'a028e9bfba6d952e407c4571450dcccde0711d518342a2e5b1e4599e33c80ffe'
AND (
token = 'HPsSsfe37PMQrgO0nRuYgLElncrXqHE1YgWqkim4zX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)