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