UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80uyEeRbMMeWxYsnSXaCWfBOHqPIdBt90Z/BnYGS+Qw='
WHERE
key_id = '6e1bdf9cbcba6c60ab5061f7af3d429a2bea622bab56b53ed22b2356396d3c5e'
AND (
token = '80uyEeRbMMeWxYsnSXaCWfBOHqPIdBt90Z/BnYGS+Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)