UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gGq+faT6qdDEqmY9KP7ChFIqU9jIcsSB+1U15EHVxf4='
WHERE
key_id = 'c9bb7c5394ef442cfffbf62bd6cfe764b27e7fdd3be80e6c77cde7d6fd93d9f3'
AND (
token = 'gGq+faT6qdDEqmY9KP7ChFIqU9jIcsSB+1U15EHVxf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)