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