UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2CQ70WmYAzXeGzEa2VcydhBYuPF4dduW9N9np0ohUQc='
WHERE
key_id = '7de5052db71974d0eebbcd2c7be2aa847a4fab4e66acc7da66e827b4b2828cf3'
AND (
token = '2CQ70WmYAzXeGzEa2VcydhBYuPF4dduW9N9np0ohUQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)