UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'orUj1OvRbWee5JmL7XszEbOWjuL1+H54fcH1bszhN4Q='
WHERE
key_id = 'd0d80c6fc9c2cf2bd584cca23632fd61bde94e621de5060df8672a85f4fc2817'
AND (
token = 'orUj1OvRbWee5JmL7XszEbOWjuL1+H54fcH1bszhN4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)