UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3D7TpJLkkNLGRUHOOm4HvZdKlhh0OzHszbnMLHtqqHA='
WHERE
key_id = '92f43d3dbcb981409e7d24f30e4be49e1e41edfab61bbe43009c4180b1892934'
AND (
token = '3D7TpJLkkNLGRUHOOm4HvZdKlhh0OzHszbnMLHtqqHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)