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