UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dG5+JTLKcOFeBPm5Pr+vJ+sQwyo6yz6QNj1+tKg/zDE='
WHERE
key_id = 'e31a21ca4147690d6fef7d14e54ac3e8017670c8493a886b7824c72c02cec909'
AND (
token = 'dG5+JTLKcOFeBPm5Pr+vJ+sQwyo6yz6QNj1+tKg/zDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)