UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EDnFZy63NSWBfFG44orXfn1Jv/hPudqCy0JkgKJJwoI='
WHERE
key_id = '714ed5c87dc0166f0ec3a4c1e542cba99595d6d88574065081e5c1260312193b'
AND (
token = 'EDnFZy63NSWBfFG44orXfn1Jv/hPudqCy0JkgKJJwoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)